Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 319208 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 29.2 MiB |
| Average record size in memory | 96.0 B |
Variable types
| Numeric | 12 |
|---|
df_index is highly correlated with ID | High correlation |
ID is highly correlated with df_index | High correlation |
u is highly correlated with g and 6 other fields | High correlation |
g is highly correlated with u and 7 other fields | High correlation |
r is highly correlated with u and 7 other fields | High correlation |
i is highly correlated with u and 7 other fields | High correlation |
z is highly correlated with u and 7 other fields | High correlation |
uErr is highly correlated with u and 7 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 8 other fields | High correlation |
iErr is highly correlated with g and 7 other fields | High correlation |
zErr is highly correlated with gErr and 2 other fields | High correlation |
df_index is highly correlated with ID | High correlation |
ID is highly correlated with df_index | High correlation |
u is highly correlated with g and 5 other fields | High correlation |
g is highly correlated with u and 5 other fields | High correlation |
r is highly correlated with u and 5 other fields | High correlation |
i is highly correlated with u and 5 other fields | High correlation |
z is highly correlated with u and 5 other fields | High correlation |
uErr is highly correlated with u and 5 other fields | High correlation |
gErr is highly correlated with u and 6 other fields | High correlation |
rErr is highly correlated with gErr and 1 other fields | High correlation |
iErr is highly correlated with rErr | High correlation |
df_index is highly correlated with ID | High correlation |
ID is highly correlated with df_index | High correlation |
u is highly correlated with g and 5 other fields | High correlation |
g is highly correlated with u and 6 other fields | High correlation |
r is highly correlated with u and 6 other fields | High correlation |
i is highly correlated with u and 6 other fields | High correlation |
z is highly correlated with u and 6 other fields | High correlation |
uErr is highly correlated with u and 6 other fields | High correlation |
gErr is highly correlated with u and 7 other fields | High correlation |
rErr is highly correlated with g and 7 other fields | High correlation |
iErr is highly correlated with gErr and 2 other fields | High correlation |
zErr is highly correlated with rErr and 1 other fields | High correlation |
df_index is highly correlated with ID | High correlation |
ID is highly correlated with df_index | High correlation |
u is highly correlated with g and 4 other fields | High correlation |
g is highly correlated with u and 6 other fields | High correlation |
r is highly correlated with u and 6 other fields | High correlation |
i is highly correlated with u and 5 other fields | High correlation |
z is highly correlated with u and 3 other fields | High correlation |
uErr is highly correlated with u | High correlation |
gErr is highly correlated with g and 3 other fields | High correlation |
rErr is highly correlated with g and 4 other fields | High correlation |
iErr is highly correlated with g and 5 other fields | High correlation |
zErr is highly correlated with iErr | High correlation |
rErr is highly skewed (γ1 = 54.93743197) | Skewed |
iErr is highly skewed (γ1 = 90.19458746) | Skewed |
zErr is highly skewed (γ1 = 172.4633831) | Skewed |
ID has unique values | Unique |
uErr has unique values | Unique |
gErr has unique values | Unique |
rErr has unique values | Unique |
iErr has unique values | Unique |
zErr has unique values | Unique |
Reproduction
| Analysis started | 2022-02-24 03:28:50.843873 |
|---|---|
| Analysis finished | 2022-02-24 03:29:29.683399 |
| Duration | 38.84 seconds |
| Software version | pandas-profiling v3.1.1 |
| Download configuration | config.json |
| Distinct | 97980 |
|---|---|
| Distinct (%) | 30.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40979.24784 |
| Minimum | 0 |
|---|---|
| Maximum | 97979 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4033 |
| Q1 | 20168 |
| median | 40346 |
| Q3 | 60531.25 |
| 95-th percentile | 82018.65 |
| Maximum | 97979 |
| Range | 97979 |
| Interquartile range (IQR) | 40363.25 |
Descriptive statistics
| Standard deviation | 24455.83284 |
|---|---|
| Coefficient of variation (CV) | 0.5967857911 |
| Kurtosis | -0.9120990318 |
| Mean | 40979.24784 |
| Median Absolute Deviation (MAD) | 20182 |
| Skewness | 0.1773169409 |
| Sum | 1.308090374 × 1010 |
| Variance | 598087760 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 48859 | 4 | < 0.1% |
| 48865 | 4 | < 0.1% |
| 48864 | 4 | < 0.1% |
| 48863 | 4 | < 0.1% |
| 48862 | 4 | < 0.1% |
| 48861 | 4 | < 0.1% |
| 48860 | 4 | < 0.1% |
| 48857 | 4 | < 0.1% |
| 48867 | 4 | < 0.1% |
| Other values (97970) | 319168 |
| Value | Count | Frequency (%) |
| 0 | 4 | |
| 1 | 4 | |
| 2 | 4 | |
| 3 | 4 | |
| 4 | 3 | |
| 5 | 4 | |
| 6 | 4 | |
| 7 | 4 | |
| 8 | 4 | |
| 9 | 4 |
| Value | Count | Frequency (%) |
| 97979 | 1 | |
| 97978 | 1 | |
| 97977 | 1 | |
| 97976 | 1 | |
| 97975 | 1 | |
| 97974 | 1 | |
| 97973 | 1 | |
| 97972 | 1 | |
| 97971 | 1 | |
| 97970 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.237664596 × 1018 |
| Minimum | 1.23764588 × 1018 |
|---|---|
| Maximum | 1.237680531 × 1018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 1.23764588 × 1018 |
|---|---|
| 5-th percentile | 1.237651497 × 1018 |
| Q1 | 1.237658492 × 1018 |
| median | 1.237663783 × 1018 |
| Q3 | 1.237668298 × 1018 |
| 95-th percentile | 1.237679543 × 1018 |
| Maximum | 1.237680531 × 1018 |
| Range | 3.465177858 × 1013 |
| Interquartile range (IQR) | 9.805951091 × 1012 |
Descriptive statistics
| Standard deviation | 8.395202021 × 1012 |
|---|---|
| Coefficient of variation (CV) | 6.783099434 × 10-6 |
| Kurtosis | -0.5679826921 |
| Mean | 1.237664596 × 1018 |
| Median Absolute Deviation (MAD) | 4.713716777 × 1012 |
| Skewness | 0.3631085514 |
| Sum | -1.477475714 × 1018 |
| Variance | 7.047941697 × 1025 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.237645943 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| 1.237667211 × 1018 | 1 | < 0.1% |
| Other values (319198) | 319198 |
| Value | Count | Frequency (%) |
| 1.23764588 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 |
| Value | Count | Frequency (%) |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 |
| Distinct | 298932 |
|---|---|
| Distinct (%) | 93.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.95571241 |
| Minimum | 11.754014 |
|---|---|
| Maximum | 30.553564 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 11.754014 |
|---|---|
| 5-th percentile | 19.58619625 |
| Q1 | 21.0533355 |
| median | 22.0237545 |
| Q3 | 22.7759675 |
| 95-th percentile | 24.3148458 |
| Maximum | 30.553564 |
| Range | 18.79955 |
| Interquartile range (IQR) | 1.722632 |
Descriptive statistics
| Standard deviation | 1.441545897 |
|---|---|
| Coefficient of variation (CV) | 0.06565698574 |
| Kurtosis | 1.300361176 |
| Mean | 21.95571241 |
| Median Absolute Deviation (MAD) | 0.8494615 |
| Skewness | 0.0171208624 |
| Sum | 7008439.047 |
| Variance | 2.078054572 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21.833239 | 5 | < 0.1% |
| 21.812965 | 5 | < 0.1% |
| 22.265358 | 5 | < 0.1% |
| 20.614471 | 4 | < 0.1% |
| 22.109701 | 4 | < 0.1% |
| 22.750834 | 4 | < 0.1% |
| 22.046278 | 4 | < 0.1% |
| 20.818539 | 4 | < 0.1% |
| 22.123411 | 4 | < 0.1% |
| 22.415571 | 4 | < 0.1% |
| Other values (298922) | 319165 |
| Value | Count | Frequency (%) |
| 11.754014 | 1 | |
| 12.345327 | 1 | |
| 12.458881 | 1 | |
| 13.230087 | 1 | |
| 13.356975 | 1 | |
| 13.587913 | 1 | |
| 13.882559 | 1 | |
| 13.946134 | 1 | |
| 13.984825 | 1 | |
| 14.093331 | 1 |
| Value | Count | Frequency (%) |
| 30.553564 | 1 | |
| 28.827219 | 1 | |
| 28.809177 | 1 | |
| 28.111626 | 1 | |
| 27.910955 | 1 | |
| 27.908926 | 1 | |
| 27.761436 | 1 | |
| 27.746222 | 1 | |
| 27.733286 | 1 | |
| 27.712788 | 1 |
| Distinct | 299157 |
|---|---|
| Distinct (%) | 93.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.1937704 |
| Minimum | 11.576696 |
|---|---|
| Maximum | 30.612074 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 11.576696 |
|---|---|
| 5-th percentile | 17.95138795 |
| Q1 | 19.1950795 |
| median | 20.3703585 |
| Q3 | 21.16579325 |
| 95-th percentile | 22.1656982 |
| Maximum | 30.612074 |
| Range | 19.035378 |
| Interquartile range (IQR) | 1.97071375 |
Descriptive statistics
| Standard deviation | 1.350955053 |
|---|---|
| Coefficient of variation (CV) | 0.06689959459 |
| Kurtosis | 0.2018201373 |
| Mean | 20.1937704 |
| Median Absolute Deviation (MAD) | 0.9432195 |
| Skewness | -0.3866214376 |
| Sum | 6446013.063 |
| Variance | 1.825079556 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21.640287 | 5 | < 0.1% |
| 21.550108 | 5 | < 0.1% |
| 18.903942 | 5 | < 0.1% |
| 20.575998 | 4 | < 0.1% |
| 20.223818 | 4 | < 0.1% |
| 21.18248 | 4 | < 0.1% |
| 20.832115 | 4 | < 0.1% |
| 19.77223 | 4 | < 0.1% |
| 20.772346 | 4 | < 0.1% |
| 20.738197 | 4 | < 0.1% |
| Other values (299147) | 319165 |
| Value | Count | Frequency (%) |
| 11.576696 | 1 | |
| 12.129926 | 1 | |
| 12.27673 | 1 | |
| 12.551465 | 1 | |
| 12.704343 | 1 | |
| 12.912142 | 1 | |
| 12.922514 | 1 | |
| 12.953435 | 1 | |
| 13.014481 | 1 | |
| 13.034089 | 1 |
| Value | Count | Frequency (%) |
| 30.612074 | 1 | |
| 29.717215 | 1 | |
| 27.497858 | 1 | |
| 26.724417 | 1 | |
| 26.632187 | 1 | |
| 26.397114 | 1 | |
| 26.121351 | 1 | |
| 25.969074 | 1 | |
| 25.873743 | 1 | |
| 25.741123 | 1 |
| Distinct | 296257 |
|---|---|
| Distinct (%) | 92.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.69537737 |
| Minimum | 11.48799 |
|---|---|
| Maximum | 29.998732 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 11.48799 |
|---|---|
| 5-th percentile | 16.94530785 |
| Q1 | 17.8054985 |
| median | 18.713879 |
| Q3 | 19.44761225 |
| 95-th percentile | 20.585991 |
| Maximum | 29.998732 |
| Range | 18.510742 |
| Interquartile range (IQR) | 1.64211375 |
Descriptive statistics
| Standard deviation | 1.160189529 |
|---|---|
| Coefficient of variation (CV) | 0.06205756136 |
| Kurtosis | 0.1339707822 |
| Mean | 18.69537737 |
| Median Absolute Deviation (MAD) | 0.81902 |
| Skewness | -0.07176924683 |
| Sum | 5967714.02 |
| Variance | 1.346039742 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.731112 | 5 | < 0.1% |
| 19.175585 | 4 | < 0.1% |
| 18.609158 | 4 | < 0.1% |
| 19.115303 | 4 | < 0.1% |
| 19.154961 | 4 | < 0.1% |
| 18.951262 | 4 | < 0.1% |
| 18.758255 | 4 | < 0.1% |
| 17.995655 | 4 | < 0.1% |
| 17.561918 | 4 | < 0.1% |
| 19.277868 | 4 | < 0.1% |
| Other values (296247) | 319167 |
| Value | Count | Frequency (%) |
| 11.48799 | 1 | |
| 11.550475 | 1 | |
| 11.657546 | 1 | |
| 11.762335 | 1 | |
| 11.884485 | 1 | |
| 11.946547 | 1 | |
| 12.018159 | 1 | |
| 12.22333 | 1 | |
| 12.245132 | 1 | |
| 12.391564 | 1 |
| Value | Count | Frequency (%) |
| 29.998732 | 1 | |
| 29.346752 | 1 | |
| 27.399418 | 1 | |
| 25.801075 | 1 | |
| 24.835089 | 1 | |
| 24.755783 | 1 | |
| 24.755745 | 1 | |
| 24.750845 | 1 | |
| 24.749956 | 1 | |
| 24.746508 | 1 |
| Distinct | 293614 |
|---|---|
| Distinct (%) | 92.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.06930171 |
| Minimum | 11.023721 |
|---|---|
| Maximum | 29.780376 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 11.023721 |
|---|---|
| 5-th percentile | 16.49034515 |
| Q1 | 17.29459775 |
| median | 18.107736 |
| Q3 | 18.7590085 |
| 95-th percentile | 19.6816762 |
| Maximum | 29.780376 |
| Range | 18.756655 |
| Interquartile range (IQR) | 1.46441075 |
Descriptive statistics
| Standard deviation | 1.028597323 |
|---|---|
| Coefficient of variation (CV) | 0.05692512854 |
| Kurtosis | 0.520610338 |
| Mean | 18.06930171 |
| Median Absolute Deviation (MAD) | 0.732417 |
| Skewness | -0.1574208866 |
| Sum | 5767865.661 |
| Variance | 1.058012452 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17.660761 | 4 | < 0.1% |
| 18.552107 | 4 | < 0.1% |
| 17.312996 | 4 | < 0.1% |
| 18.724926 | 4 | < 0.1% |
| 18.694399 | 4 | < 0.1% |
| 18.536222 | 4 | < 0.1% |
| 18.253174 | 4 | < 0.1% |
| 18.328253 | 4 | < 0.1% |
| 18.18195 | 4 | < 0.1% |
| 16.890148 | 4 | < 0.1% |
| Other values (293604) | 319168 |
| Value | Count | Frequency (%) |
| 11.023721 | 1 | |
| 11.171733 | 1 | |
| 11.22397 | 1 | |
| 11.303094 | 1 | |
| 11.486779 | 1 | |
| 11.847364 | 1 | |
| 11.913856 | 1 | |
| 11.92277 | 1 | |
| 11.995991 | 1 | |
| 12.019981 | 1 |
| Value | Count | Frequency (%) |
| 29.780376 | 1 | |
| 27.96781 | 1 | |
| 25.775478 | 1 | |
| 24.723509 | 1 | |
| 24.591396 | 1 | |
| 24.410803 | 1 | |
| 24.401884 | 1 | |
| 24.339972 | 1 | |
| 24.338566 | 1 | |
| 24.331234 | 1 |
| Distinct | 292925 |
|---|---|
| Distinct (%) | 91.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.70313181 |
| Minimum | 10.680226 |
|---|---|
| Maximum | 28.568005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 10.680226 |
|---|---|
| 5-th percentile | 16.1608012 |
| Q1 | 16.9609125 |
| median | 17.735658 |
| Q3 | 18.3682895 |
| 95-th percentile | 19.27754315 |
| Maximum | 28.568005 |
| Range | 17.887779 |
| Interquartile range (IQR) | 1.407377 |
Descriptive statistics
| Standard deviation | 1.005014595 |
|---|---|
| Coefficient of variation (CV) | 0.05677044071 |
| Kurtosis | 0.712640595 |
| Mean | 17.70313181 |
| Median Absolute Deviation (MAD) | 0.7055785 |
| Skewness | -0.1115929196 |
| Sum | 5650981.3 |
| Variance | 1.010054336 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16.892282 | 5 | < 0.1% |
| 17.695036 | 4 | < 0.1% |
| 17.949966 | 4 | < 0.1% |
| 16.66597 | 4 | < 0.1% |
| 17.952662 | 4 | < 0.1% |
| 19.199499 | 4 | < 0.1% |
| 17.85078 | 4 | < 0.1% |
| 17.94887 | 4 | < 0.1% |
| 18.300514 | 4 | < 0.1% |
| 17.487617 | 4 | < 0.1% |
| Other values (292915) | 319167 |
| Value | Count | Frequency (%) |
| 10.680226 | 1 | |
| 10.902326 | 1 | |
| 10.932217 | 1 | |
| 10.971477 | 1 | |
| 11.148276 | 1 | |
| 11.52019 | 1 | |
| 11.540811 | 1 | |
| 11.54752 | 1 | |
| 11.591019 | 1 | |
| 11.687567 | 1 |
| Value | Count | Frequency (%) |
| 28.568005 | 1 | |
| 27.737377 | 1 | |
| 24.666559 | 1 | |
| 24.346718 | 1 | |
| 24.117994 | 1 | |
| 23.650806 | 1 | |
| 23.553709 | 1 | |
| 23.539772 | 1 | |
| 23.521828 | 1 | |
| 23.491987 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4094936765 |
| Minimum | 0.01319976295 |
|---|---|
| Maximum | 6.87985948 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0.01319976295 |
|---|---|
| 5-th percentile | 0.06318262868 |
| Q1 | 0.1789683518 |
| median | 0.3378770764 |
| Q3 | 0.5512002404 |
| 95-th percentile | 1.0066717 |
| Maximum | 6.87985948 |
| Range | 6.866659717 |
| Interquartile range (IQR) | 0.3722318886 |
Descriptive statistics
| Standard deviation | 0.3121141486 |
|---|---|
| Coefficient of variation (CV) | 0.7621952828 |
| Kurtosis | 6.787888315 |
| Mean | 0.4094936765 |
| Median Absolute Deviation (MAD) | 0.1772724946 |
| Skewness | 1.781553518 |
| Sum | 130713.6575 |
| Variance | 0.09741524173 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.3126673977 | 1 | < 0.1% |
| 0.0912450317 | 1 | < 0.1% |
| 0.3299582349 | 1 | < 0.1% |
| 0.282299437 | 1 | < 0.1% |
| 0.2381450035 | 1 | < 0.1% |
| 0.3309859821 | 1 | < 0.1% |
| 0.09601819535 | 1 | < 0.1% |
| 0.3735594867 | 1 | < 0.1% |
| 0.4398266602 | 1 | < 0.1% |
| 0.07825624964 | 1 | < 0.1% |
| Other values (319198) | 319198 |
| Value | Count | Frequency (%) |
| 0.01319976295 | 1 | |
| 0.01335124523 | 1 | |
| 0.01373493225 | 1 | |
| 0.01378111571 | 1 | |
| 0.01401705579 | 1 | |
| 0.01419630977 | 1 | |
| 0.0142992412 | 1 | |
| 0.01437876316 | 1 | |
| 0.01441737656 | 1 | |
| 0.01455504511 | 1 |
| Value | Count | Frequency (%) |
| 6.87985948 | 1 | |
| 6.742928143 | 1 | |
| 5.624479585 | 1 | |
| 5.087197718 | 1 | |
| 4.385355573 | 1 | |
| 4.187609544 | 1 | |
| 4.105101217 | 1 | |
| 4.009547602 | 1 | |
| 4.000261639 | 1 | |
| 3.95019859 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09055997065 |
| Minimum | 0.02266076487 |
|---|---|
| Maximum | 6.429339305 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0.02266076487 |
|---|---|
| 5-th percentile | 0.03280795075 |
| Q1 | 0.04590485922 |
| median | 0.07179831984 |
| Q3 | 0.1095478901 |
| 95-th percentile | 0.2045915797 |
| Maximum | 6.429339305 |
| Range | 6.40667854 |
| Interquartile range (IQR) | 0.06364303084 |
Descriptive statistics
| Standard deviation | 0.08046237555 |
|---|---|
| Coefficient of variation (CV) | 0.8884982512 |
| Kurtosis | 544.4833595 |
| Mean | 0.09055997065 |
| Median Absolute Deviation (MAD) | 0.02922428509 |
| Skewness | 12.58737434 |
| Sum | 28907.46711 |
| Variance | 0.00647419388 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.05322089396 | 1 | < 0.1% |
| 0.03103795061 | 1 | < 0.1% |
| 0.06429976871 | 1 | < 0.1% |
| 0.07083389133 | 1 | < 0.1% |
| 0.052395459 | 1 | < 0.1% |
| 0.05424624981 | 1 | < 0.1% |
| 0.0288373313 | 1 | < 0.1% |
| 0.05619117013 | 1 | < 0.1% |
| 0.0700877008 | 1 | < 0.1% |
| 0.03277780567 | 1 | < 0.1% |
| Other values (319198) | 319198 |
| Value | Count | Frequency (%) |
| 0.02266076487 | 1 | |
| 0.02282897274 | 1 | |
| 0.02310271782 | 1 | |
| 0.02311547278 | 1 | |
| 0.02314455778 | 1 | |
| 0.02323303193 | 1 | |
| 0.02331523775 | 1 | |
| 0.02333767652 | 1 | |
| 0.02339651578 | 1 | |
| 0.02339853652 | 1 |
| Value | Count | Frequency (%) |
| 6.429339305 | 1 | |
| 6.232147577 | 1 | |
| 5.301634952 | 1 | |
| 5.275434365 | 1 | |
| 4.705393845 | 1 | |
| 4.126417778 | 1 | |
| 3.92779142 | 1 | |
| 3.885418222 | 1 | |
| 3.802731294 | 1 | |
| 3.736464955 | 1 |
rErr
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDUNIQUE| Distinct | 319208 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07355135891 |
| Minimum | 0.03485844218 |
|---|---|
| Maximum | 7.180163959 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0.03485844218 |
|---|---|
| 5-th percentile | 0.04587208495 |
| Q1 | 0.05383030746 |
| median | 0.06390395788 |
| Q3 | 0.08169309802 |
| 95-th percentile | 0.1341585255 |
| Maximum | 7.180163959 |
| Range | 7.145305517 |
| Interquartile range (IQR) | 0.02786279056 |
Descriptive statistics
| Standard deviation | 0.04240716313 |
|---|---|
| Coefficient of variation (CV) | 0.5765653248 |
| Kurtosis | 7012.291833 |
| Mean | 0.07355135891 |
| Median Absolute Deviation (MAD) | 0.01213871963 |
| Skewness | 54.93743197 |
| Sum | 23478.18217 |
| Variance | 0.001798367485 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.05142665241 | 1 | < 0.1% |
| 0.04873309259 | 1 | < 0.1% |
| 0.05988102382 | 1 | < 0.1% |
| 0.05969956506 | 1 | < 0.1% |
| 0.0603557151 | 1 | < 0.1% |
| 0.05488418013 | 1 | < 0.1% |
| 0.04443810854 | 1 | < 0.1% |
| 0.05350187052 | 1 | < 0.1% |
| 0.07584452577 | 1 | < 0.1% |
| 0.05271912723 | 1 | < 0.1% |
| Other values (319198) | 319198 |
| Value | Count | Frequency (%) |
| 0.03485844218 | 1 | |
| 0.03535379817 | 1 | |
| 0.03542247378 | 1 | |
| 0.03582003744 | 1 | |
| 0.03587685256 | 1 | |
| 0.0359197515 | 1 | |
| 0.0359423393 | 1 | |
| 0.03598042238 | 1 | |
| 0.03598916294 | 1 | |
| 0.03607572236 | 1 |
| Value | Count | Frequency (%) |
| 7.180163959 | 1 | |
| 6.165068051 | 1 | |
| 5.855121474 | 1 | |
| 4.779347244 | 1 | |
| 4.763801336 | 1 | |
| 4.742747477 | 1 | |
| 4.199696884 | 1 | |
| 4.054225263 | 1 | |
| 3.081155927 | 1 | |
| 2.784959056 | 1 |
iErr
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDUNIQUE| Distinct | 319208 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08099668136 |
| Minimum | 0.03881203054 |
|---|---|
| Maximum | 8.400347923 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0.03881203054 |
|---|---|
| 5-th percentile | 0.05671268735 |
| Q1 | 0.06526949532 |
| median | 0.07464581717 |
| Q3 | 0.08892923472 |
| 95-th percentile | 0.1234753837 |
| Maximum | 8.400347923 |
| Range | 8.361535893 |
| Interquartile range (IQR) | 0.0236597394 |
Descriptive statistics
| Standard deviation | 0.04822283188 |
|---|---|
| Coefficient of variation (CV) | 0.5953679962 |
| Kurtosis | 12239.40423 |
| Mean | 0.08099668136 |
| Median Absolute Deviation (MAD) | 0.0109526043 |
| Skewness | 90.19458746 |
| Sum | 25854.78866 |
| Variance | 0.002325441514 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.05573130436 | 1 | < 0.1% |
| 0.06747099147 | 1 | < 0.1% |
| 0.07508066305 | 1 | < 0.1% |
| 0.07601255228 | 1 | < 0.1% |
| 0.07986495558 | 1 | < 0.1% |
| 0.06948734313 | 1 | < 0.1% |
| 0.06021585485 | 1 | < 0.1% |
| 0.06739488578 | 1 | < 0.1% |
| 0.1013629108 | 1 | < 0.1% |
| 0.07355645798 | 1 | < 0.1% |
| Other values (319198) | 319198 |
| Value | Count | Frequency (%) |
| 0.03881203054 | 1 | |
| 0.04270086665 | 1 | |
| 0.04301709522 | 1 | |
| 0.04312907944 | 1 | |
| 0.04348102676 | 1 | |
| 0.04363486267 | 1 | |
| 0.04377561951 | 1 | |
| 0.04385961229 | 1 | |
| 0.04397806812 | 1 | |
| 0.04398176805 | 1 |
| Value | Count | Frequency (%) |
| 8.400347923 | 1 | |
| 8.038223374 | 1 | |
| 7.864687125 | 1 | |
| 6.48909048 | 1 | |
| 5.962899652 | 1 | |
| 5.953983347 | 1 | |
| 5.799106136 | 1 | |
| 5.697022025 | 1 | |
| 5.422591777 | 1 | |
| 4.829551119 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.11688808 |
| Minimum | 0.04474935232 |
|---|---|
| Maximum | 29.87530183 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 MiB |
Quantile statistics
| Minimum | 0.04474935232 |
|---|---|
| 5-th percentile | 0.07541476358 |
| Q1 | 0.09084386398 |
| median | 0.1066164109 |
| Q3 | 0.1293862815 |
| 95-th percentile | 0.1851948687 |
| Maximum | 29.87530183 |
| Range | 29.83055248 |
| Interquartile range (IQR) | 0.03854241756 |
Descriptive statistics
| Standard deviation | 0.09020147448 |
|---|---|
| Coefficient of variation (CV) | 0.7716909584 |
| Kurtosis | 48261.30785 |
| Mean | 0.11688808 |
| Median Absolute Deviation (MAD) | 0.01815410665 |
| Skewness | 172.4633831 |
| Sum | 37311.61024 |
| Variance | 0.008136305998 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.07544027706 | 1 | < 0.1% |
| 0.111877185 | 1 | < 0.1% |
| 0.1139333025 | 1 | < 0.1% |
| 0.1161216066 | 1 | < 0.1% |
| 0.1249402832 | 1 | < 0.1% |
| 0.1014513046 | 1 | < 0.1% |
| 0.09187635468 | 1 | < 0.1% |
| 0.09903003259 | 1 | < 0.1% |
| 0.1625481527 | 1 | < 0.1% |
| 0.1291232525 | 1 | < 0.1% |
| Other values (319198) | 319198 |
| Value | Count | Frequency (%) |
| 0.04474935232 | 1 | |
| 0.04565870618 | 1 | |
| 0.04893893067 | 1 | |
| 0.04904532431 | 1 | |
| 0.04920480286 | 1 | |
| 0.04923784125 | 1 | |
| 0.04937254716 | 1 | |
| 0.04937580216 | 1 | |
| 0.0493958452 | 1 | |
| 0.04942044052 | 1 |
| Value | Count | Frequency (%) |
| 29.87530183 | 1 | |
| 20.34444513 | 1 | |
| 15.39946874 | 1 | |
| 9.034809081 | 1 | |
| 8.540151462 | 1 | |
| 4.74786487 | 1 | |
| 4.196299858 | 1 | |
| 3.807162722 | 1 | |
| 3.493246011 | 1 | |
| 3.492410546 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1237645942905110768 | 22.373924 | 20.301023 | 18.914286 | 18.431997 | 18.159517 | 0.312667 | 0.053221 | 0.051427 | 0.055731 | 0.075440 |
| 1 | 1 | 1237645942905569773 | 22.497066 | 20.952272 | 19.394960 | 18.853279 | 18.434809 | 0.542727 | 0.115557 | 0.079184 | 0.079735 | 0.109295 |
| 2 | 2 | 1237645943978328381 | 22.678976 | 21.650578 | 19.886253 | 19.214005 | 18.839323 | 0.529001 | 0.153088 | 0.088523 | 0.088252 | 0.112267 |
| 3 | 3 | 1237645943978524819 | 21.032383 | 18.865986 | 17.561859 | 17.133131 | 16.829306 | 0.179582 | 0.040455 | 0.049065 | 0.059050 | 0.074079 |
| 4 | 4 | 1237645943978524889 | 21.576267 | 20.216810 | 18.495819 | 17.974495 | 17.614441 | 0.257184 | 0.067614 | 0.056028 | 0.063211 | 0.076636 |
| 5 | 5 | 1237645943978590518 | 21.165874 | 19.130669 | 17.668627 | 17.227806 | 16.949409 | 0.267951 | 0.055352 | 0.059208 | 0.070057 | 0.091337 |
| 6 | 6 | 1237645943978590761 | 23.827118 | 22.266033 | 20.510069 | 19.850769 | 19.492815 | 0.725661 | 0.199855 | 0.098939 | 0.093719 | 0.125562 |
| 7 | 7 | 1237645943978656051 | 21.894428 | 20.380268 | 18.853308 | 18.346809 | 17.944668 | 0.350742 | 0.076074 | 0.061399 | 0.066141 | 0.161078 |
| 8 | 8 | 1237645943978721502 | 22.077801 | 20.384060 | 19.022602 | 18.587086 | 18.295713 | 0.342619 | 0.065458 | 0.058150 | 0.065043 | 0.079621 |
| 9 | 9 | 1237645943978721546 | 21.390770 | 20.250340 | 18.936052 | 18.488092 | 18.206268 | 0.244976 | 0.073216 | 0.065740 | 0.072660 | 0.089991 |
Last rows
| df_index | ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 319198 | 75915 | 1237680530815255780 | 24.336834 | 21.418812 | 19.511326 | 18.806894 | 18.356859 | 1.048435 | 0.114328 | 0.078506 | 0.088951 | 0.102196 |
| 319199 | 75916 | 1237680530815713981 | 23.457827 | 21.231998 | 19.377743 | 18.688829 | 18.210978 | 0.960536 | 0.124057 | 0.082271 | 0.093221 | 0.116708 |
| 319200 | 75917 | 1237680530816500748 | 22.759562 | 21.769369 | 20.680836 | 19.656219 | 19.288139 | 0.785910 | 0.217212 | 0.211030 | 0.181929 | 0.238482 |
| 319201 | 75918 | 1237680530816631981 | 23.903332 | 22.321108 | 20.874950 | 19.793472 | 19.283394 | 1.168363 | 0.279190 | 0.206576 | 0.163526 | 0.209199 |
| 319202 | 75919 | 1237680530817418390 | 22.273611 | 20.699070 | 19.874216 | 19.129982 | 18.757246 | 0.719786 | 0.132274 | 0.174994 | 0.186624 | 0.240496 |
| 319203 | 75920 | 1237680530817483117 | 25.541300 | 21.284241 | 19.378674 | 18.579559 | 18.137300 | 0.904565 | 0.217660 | 0.152072 | 0.166066 | 0.193869 |
| 319204 | 75921 | 1237680530819187411 | 26.020273 | 21.844044 | 20.219097 | 19.308535 | 18.892942 | 0.481163 | 0.199816 | 0.142057 | 0.139065 | 0.175742 |
| 319205 | 75922 | 1237680530819253214 | 22.185659 | 23.075047 | 21.338875 | 20.104506 | 19.579048 | 0.287064 | 0.348883 | 0.204575 | 0.146878 | 0.196234 |
| 319206 | 75923 | 1237680531354420253 | 25.849159 | 22.017805 | 20.328970 | 19.440924 | 18.843649 | 0.412766 | 0.221041 | 0.147098 | 0.140861 | 0.159505 |
| 319207 | 75924 | 1237680531356320501 | 21.989624 | 21.693808 | 20.043190 | 19.104773 | 18.551073 | 0.347256 | 0.134724 | 0.104478 | 0.100372 | 0.123098 |